Additional Worksheet Operations

Worksheet Functions

Worksheet functions take a value or values, perform an action, and return a value or values. All functions that begin with a capital letter use search criteria. Lower case functions, known as worksheet functions, require a number value or a cell range. The argument for all trigonometry functions must be in radians. The following table alphabetically lists all of the worksheet functions available in VectorWorks.

 

Code	Returns	Example	Related Functions
acos(number)	The arccosine of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 to pi. Number is the cosine of the angle, and must be from -1 to 1.	=acos(cos(x))	(cos) (pi)
Angle(criteria)	The angle of lines and walls, the span angle of arcs (in degrees), and the slope angle of slabs (in degrees)	=Angle(t=wall)
Area(criteria)	The total area of 2D objects that meet the criteria	=Area(t=rect)	(Perim)
asin(number)	The arcsine of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2. To express the arcsine in degrees use the rad2deg function (or multiply the result by 180/pi). Number is the sine of the angle in question and must be from -1 to 1.	=asin(sin(x))	(pi) (sin)
atan(number)	The arctangent of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2. To express the arctangent in degrees, multiply the result by 180/pi(). Number is the tangent of the angle in question.	=atan(tan(x))	(pi) (tan)
average(number1, number2...)	The average (mean) of the arguments	=average (85, 70, 95)	(max) (min) (sum)
BotBound(criteria)	The minimum y coordinate of objects that meet the criteria	= BotBound(sec)	(LeftBound) (RightBound) (TopBound)
cos(number)	The cosine of a given angle. Number is the angle in radians for which the cosine is calculated.	= cos(Deg2Rad(90))	(pi)
Count(criteria)	The number of objects that meet the specified criteria	= Count(sel)
deg2rad(number)	Converts number from degrees to radians. Number is the value in degrees to be converted to radians.	=deg2rad(45)
exp(number)	e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm. Number is the exponent applied to the base e.	=exp(2)	(ln)
Height(criteria)	The delta y (height) of objects	=height(t=rect)	(Width)
if (logical_test, value_if_true, value_if_false)	Use value_if_true if logical_test is true, value_is_false if logical_test is false. Use this function to conduct conditional tests on values and formulas and to branch based on the results of that test. The outcome of the test determines the value returned by the If function. The logical_test can be any value or expression that can be evaluated to true or false. Up to seven If statements can be nested as value_if_true, value_if_false arguments to construct elaborate formulas. Boolean statements within an if statement must be in parentheses. Text within an if statement should be enclosed within quotation marks.	=if((c7>100),100,c7) or =if((c7>100);100;c7) when commas are used as decimal separators by the operating system
int(number)	Removes any fractional part of a number. Number is the real number to be rounded to an integer.	=int(1.5)	(round)
IsFlipped(criteria)	Returns a value which is the total number of flipped objects which meet the criteria	=IsFlipped(t=rect)
LeftBound(criteria)	The left side minimum x (left boundary) of the objects that meet the criteria	=LeftBound(n='obj')	(BotBound) (RightBound) (TopBound)
Length(criteria)	The length of lines or walls that meet the criteria	=Length(t=line)
ln(number)	The natural logarithm (base e). Number is the positive real number for which the logarithm is calculated.	=ln(x)	(exp)
log(number)	The base 10 logarithm of a number. Number is the positive real number for which the logarithm is calculated.	=log(2)	(ln)
max(number1, number2,...)	The largest number in the list of arguments. Number is 1 – 14 numbers for which the maximum value is to be found.	=max (5,7,9)	(min)
min(number1, number2,...)	The smallest number in the list of arguments. Number is 1 – 14 numbers for which the minimum value is to be found.	=min(5,7,9)	(max)
Perim(criteria)	The perimeter of objects that meet the criteria	=Perim(sel)
rad2deg(number)	Converts number from radians to degrees. Number is the value in radians to be converted to degrees.	=rad2deg (0.5235987)
RightBound(criteria)	The right side minimum x (right boundary) of the objects that meet the criteria	=RightBound(sel)	(BotBound) (TopBound) (LeftBound)
round(number)	Rounds the specified number to the nearest whole number	=round(3.24259)	(int)
sin	The sine of a given angle	=sin(deg2rad(30))	(pi)
sqrt(number)	A positive square root. Number is the number for which the square root is calculated.	=sqrt(16)
sum(number1, number2,...)	The sum of all numbers in the list of arguments. Number is 1 – 14 numbers for which the sum is calculated.	=sum(10,20,30)	(Average)
SurfaceArea(criteria)	Returns the sum of CalcSurfaceArea for each object that meets the criteria	=SurfaceArea (t=wall)
tan(number)	The tangent of the given angle. Number is the angle in radians for which the tangent is calculated.	=tan(deg2rad(45))	(pi)
TopBound(criteria)	The maximum y (top boundary) of the objects that meet the criteria	=TopBound (n='root')	(BotBound) (LeftBound) (RightBound)
Volume(criteria)	Returns the sum of CalcVolume for each object that meets the criteria	=Volume(t=wall)
WallArea_Gross (criteria)	Returns the 2D gross surface area of one wall face	=WallArea_Gross (t=wall)	WallArea_Net
WallArea_Net(criteria)	Returns the 2D gross surface area of one wall face, without door and window areas	=WallArea_Net (t=wall)	WallArea_Gross
WallAverageHeight (criteria)	Returns the average wall height of a wall, including wall peaks and different starting and ending heights	=WallAverageHeight (t=wall)
WallStyleName(criteria)	Returns the name of a wall style	=WallStyleName (t=wall)
WallThickness(criteria)	Returns the thickness of a wall	=WallThickness (t=wall)
Width(criteria)	The delta x (width) of objects	=Width(n='box')	(Height)
XCenter(criteria)	The center of objects in the X direction	=XCenter (n=‘board’)	(YCenter)
YCenter(criteria)	The center of objects in the Y direction	=YCenter (n=‘board’)	(XCenter)